use RD_common;
go

INSERT INTO [RD_COMMON].[dbo].[Star_Item]
           ([ItemNumberID]
           ,[SourceID]
           ,[Source]
           ,[ItemNumber]
           ,[ItemNumber02]
           ,[ItemNumber03]
           ,[Description01]
           ,[Description02]
           ,[SalesCategory01Code]
           ,[SalesCategory01]
           ,[SalesCategory02Code]
           ,[SalesCategory02]
           ,[SalesCategory03Code]
           ,[SalesCategory03]
           ,[SalesCategory04Code]
           ,[SalesCategory04]
           ,[SalesCategory05Code]
           ,[SalesCategory05]
           ,[SalesCategory06Code]
           ,[SalesCategory06]
           ,[SalesCategory07Code]
           ,[SalesCategory07]
           ,[SalesCategory08Code]
           ,[SalesCategory08]
           ,[SalesCategory09Code]
           ,[SalesCategory09]
           ,[SalesCategory10Code]
           ,[SalesCategory10]
           ,[PurchasingCategory01Code]
           ,[PurchasingCategory01]
           ,[PurchasingCategory02Code]
           ,[PurchasingCategory02]
           ,[PurchasingCategory03Code]
           ,[PurchasingCategory03]
           ,[PurchasingCategory04Code]
           ,[PurchasingCategory04]
           ,[PurchasingCategory05Code]
           ,[PurchasingCategory05]
           ,[PurchasingCategory06Code]
           ,[PurchasingCategory06]
           ,[PurchasingCategory07Code]
           ,[PurchasingCategory07]
           ,[PurchasingCategory08Code]
           ,[PurchasingCategory08]
           ,[PurchasingCategory09Code]
           ,[PurchasingCategory09]
           ,[PurchasingCategory10Code]
           ,[PurchasingCategory10]
           ,[ProductGroupCode]
           ,[ProductGroup]
           ,[ItemPriceGroupCode]
           ,[ItemPriceGroup]
           ,[StockingTypeCode]
           ,[StockingType]
           ,[InsertIndicator]
           ,[InsertDate]
           ,[ChangeIndicator]
           ,[ChangeDate]
           ,[DeleteIndicator]
           ,[DeleteDate]
           ,[PurgeDate])
     VALUES
           (1
           ,1
           , 'FARMER_CUSTOM'
           ,0
           ,'Advanced Pricing Adj Line'
           , 'Advanced Pricing Adj Line'
           , 'Advanced Pricing Adj Line'
           ,''
           ,''
           ,''
           ,''
           ,''
           ,''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           , ''
           ,0
           ,0
           ,0
           ,0
           ,0
           ,0
           ,0)
